CREATE TABLE [dbo].[tb_Bloqueos]
(
[idBloque] [int] NOT NULL IDENTITY(1, 1),
[Agente] [int] NULL,
[Servicio] [int] NULL,
[Concepto] [int] NULL,
[Responsable] [int] NOT NULL,
[Observaciones] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[tb_Bloqueos] ADD CONSTRAINT [PK_tb_Bloqueos] PRIMARY KEY NONCLUSTERED  ([idBloque]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[tb_Bloqueos] WITH NOCHECK ADD CONSTRAINT [FK_tb_Bloqueos_tb_Agentes] FOREIGN KEY ([Agente]) REFERENCES [dbo].[tb_Agentes] ([idAgente])
GO
ALTER TABLE [dbo].[tb_Bloqueos] WITH NOCHECK ADD CONSTRAINT [FK_tb_Bloqueos_tb_ConceptosDeLiquidacion] FOREIGN KEY ([Concepto]) REFERENCES [dbo].[tb_ConceptosDeLiquidacion] ([idConceptoLiquidacion])
GO
ALTER TABLE [dbo].[tb_Bloqueos] WITH NOCHECK ADD CONSTRAINT [FK_tb_Bloqueos_tb_Usuarios] FOREIGN KEY ([Responsable]) REFERENCES [dbo].[tb_Usuarios] ([idUsuario])
GO
